package com.adcc.loadsheet.movingdata.mapper.mysql;

import com.adcc.loadsheet.movingdata.entity.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.UUID;

/**
 * Created by AN on 2020-04-01.
 */
@Mapper
public interface MysqlMapper {
    List<PbStaffEntity> findAllStaff();

    int updateStaff(PbStaffEntity one);

    int insertStaff(PbStaffEntity one);

    int deleteStaff(PbStaffEntity delone);

    List<PbDepartmentEntity> findAllDepart();

    int updateDepart(PbDepartmentEntity one);

    int insertDepart(PbDepartmentEntity one);

    int deleteDepart(PbDepartmentEntity delone);

    List<ScAirlinesEntity> findAllAirline();

    int updateAirline(ScAirlinesEntity one);

    int insertAirline(ScAirlinesEntity one);

    int deleteAirline(ScAirlinesEntity delone);

    List<ScAirportEntity> findAllAirport();

    int updateAirport(ScAirportEntity one);

    int insertAirport(ScAirportEntity one);

    int deleteAirport(ScAirportEntity delone);

    int deleteLoadsheet(@Param("start") String start,@Param("end") String end);

    int deleteHisLoadsheet(@Param("end") String end);

    int insertLoadsheet(ScUpDataEntity one);

    int deleteFailDate(@Param("start") String start,@Param("end") String end);

    void insertFaildate(@Param("uuid") String uuid, @Param("date")String date);

    void updatebasetime();
}
